Account Master Filter3 (GL00100F3)

azurecurve Products Microsoft Dynamics GP (0)FinancialAccount Master Filter3 (GL00100F3)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GL00100F3

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Account Master Filter3
Physical Name: GL00100F3
Technical Name: GL_Account_MSTR_Filter3

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Account Master Filter3'].ACTINDX AS 'Account Master Filter3-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM GL00100F3 AS ['Account Master Filter3'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Account Master Filter3'].ACTINDX = ['Account Index Master'].ACTINDX
2	ACTNUMBR_1	Account Number:Account_Segment_Pool1	String	Account_Segment_Pool1	6
3	ACTNUMBR_2	Account Number:Account_Segment_Pool2	String	Account_Segment_Pool2	6
4	ACTNUMBR_3	Account Number:Account_Segment_Pool3	String	Account_Segment_Pool3	6
5	ACTNUMBR_4	Account Number:Account_Segment_Pool4	String	Account_Segment_Pool4	6
6	ACTNUMBR_5	Account Number:Account_Segment_Pool5	String	Account_Segment_Pool5	6
7	ACTNUMBR_6	Account Number:Account_Segment_Pool6	String	Account_Segment_Pool6	6
8	ACTNUMBR_7	Account Number:Account_Segment_Pool7	String	Account_Segment_Pool7	6
9	ACTNUMBR_8	Account Number:Account_Segment_Pool8	String	Account_Segment_Pool8	6
10	ACTNUMBR_9	Account Number:Account_Segment_Pool9	String	Account_Segment_Pool9	6
11	ACTNUMBR_10	Account Number:Account_Segment_Pool10	String	Account_Segment_Pool10	6
12	ACTALIAS	Account Alias	String	STR20_Account_Alias	20
13	MNACSGMT	Main Account Segment	String	STR66_Seg_ID	66
14	ACCTTYPE	Account Type	Integer	DDL_Account_Type	0
15	ACTDESCR	Account Description	String	STR50	50
16	ACCATNUM	Account Category Number	Integer	INT2_U0	2
	Key to the Account Category Master (GL00102). Click to show/hide SELECT ['Account Master Filter3'].ACCATNUM AS 'Account Master Filter3-Account Category Number' ,['Account Category Master'].ACCATNUM AS 'Account Category Master-Account Category Number' FROM GL00100F3 AS ['Account Master Filter3'] INNER JOIN GL00102 AS ['Account Category Master'] ON ['Account Master Filter3'].ACCATNUM = ['Account Category Master'].ACCATNUM
17	RELID	RelationID	Long Integer	Long Int	8

azurecurve Products Microsoft Dynamics GP (0)FinancialAccount Master Filter3 (GL00100F3)

Leave a Reply Cancel reply